------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
 opened on:  23 Nov 2021, 16:54:56

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
 paused on:  23 Nov 2021, 16:54:56
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
resumed on:  23 Nov 2021, 16:54:56

. tab gender ;

      Q55 - |
Gender (= 1 |
   if Male) |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      1,236       49.22       49.22
   .4191853 |         49        1.95       51.17
   .4931921 |         42        1.67       52.85
   .5080386 |         65        2.59       55.44
          1 |      1,119       44.56      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. tab county ;

  County of |
  residence |
(G=Guilford |
  , W=Wake, |
M=Mecklenbu |
        rg) |      Freq.     Percent        Cum.
------------+-----------------------------------
          G |        810       32.26       32.26
          M |        703       28.00       60.25
          W |        998       39.75      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. sum income, detail ;

                   Q59 - Household Income
-------------------------------------------------------------
      Percentiles      Smallest
 1%        10000          10000
 5%        10000          10000
10%        25000          10000       Obs               2,511
25%        55000          10000       Sum of Wgt.       2,511

50%        87500                      Mean           99130.84
                        Largest       Std. Dev.      61630.62
75%       137500         225000
90%       225000         225000       Variance       3.80e+09
95%       225000         225000       Skewness       .6616972
99%       225000         225000       Kurtosis          2.546

. tab covid19 ;

     Q288 - |
COVID19 had |
         no |
 effect(0), |
       less |
 likely(1), |
       more |
  likely(2) |
to vote for |
       act  |      Freq.     Percent        Cum.
------------+-----------------------------------
         -1 |        134        5.34        5.34
          0 |      1,789       71.25       76.58
          1 |        148        5.89       82.48
          2 |        440       17.52      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. tab debrief_1 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 my answers |
      might |
  influence |
  design of |
     future |
   policies |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,181       49.09       49.09
          D |        144        5.99       55.07
          N |        749       31.13       86.20
         SA |        283       11.76       97.96
         SD |         49        2.04      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_2 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 believable |
    that my |
  household |
 would have |
     to pay |
    higher  |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,267       52.66       52.66
          D |         68        2.83       55.49
          N |        194        8.06       63.55
         SA |        851       35.37       98.92
         SD |         26        1.08      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_3 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     choose |
 disagree - |
       trap |
   question |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |         74        3.08        3.08
          D |      2,184       90.77       93.85
          N |         87        3.62       97.46
         SA |         32        1.33       98.79
         SD |         29        1.21      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_4 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 considered |
   both the |
improved wq |
    and the |
costs to hh |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,253       52.08       52.08
          D |         38        1.58       53.66
          N |        122        5.07       58.73
         SA |        974       40.48       99.21
         SD |         19        0.79      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_5 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     stream |
      water |
quality are |
 valuable / |
  something |
    WTP for |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,133       47.09       47.09
          D |        171        7.11       54.20
          N |        519       21.57       75.77
         SA |        543       22.57       98.34
         SD |         40        1.66      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_6 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     doubts |
county govt |
    will be |
    able to |
    improve |
  stream wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        726       30.17       30.17
          D |        547       22.73       52.91
          N |        822       34.16       87.07
         SA |        253       10.52       97.59
         SD |         58        2.41      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_7 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 opposed to |
     higher |
  taxes, no |
matter what |
   they are |
      used  |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        324       13.47       13.47
          D |        964       40.07       53.53
          N |        539       22.40       75.94
         SA |        198        8.23       84.16
         SD |        381       15.84      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_8 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
provided me |
with enough |
    info to |
       make |
   informed |
     choice |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,453       60.39       60.39
          D |         94        3.91       64.30
          N |        307       12.76       77.06
         SA |        540       22.44       99.50
         SD |         12        0.50      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_9 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
  no effect |
   on other |
 streams or |
  on lake / |
   river wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,216       50.54       50.54
          D |         70        2.91       53.45
          N |        215        8.94       62.39
         SA |        889       36.95       99.33
         SD |         16        0.67      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_10 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
   describe |
  myself as |
         an |
environment |
      alist |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        800       33.25       33.25
          D |        313       13.01       46.26
          N |      1,003       41.69       87.95
         SA |        221        9.19       97.13
         SD |         69        2.87      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_11 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 survey was |
objective / |
 didnt push |
 me to vote |
  for/again |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,317       54.74       54.74
          D |        102        4.24       58.98
          N |        358       14.88       73.86
         SA |        601       24.98       98.84
         SD |         28        1.16      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_9 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
  no effect |
   on other |
 streams or |
  on lake / |
   river wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,216       50.54       50.54
          D |         70        2.91       53.45
          N |        215        8.94       62.39
         SA |        889       36.95       99.33
         SD |         16        0.67      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_9 if inlist(debrief_10,"SA","A") ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
  no effect |
   on other |
 streams or |
  on lake / |
   river wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        486       47.60       47.60
          D |         25        2.45       50.05
          N |         53        5.19       55.24
         SA |        451       44.17       99.41
         SD |          6        0.59      100.00
------------+-----------------------------------
      Total |      1,021      100.00

. tab debrief_9 if inlist(college,1) ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
  no effect |
   on other |
 streams or |
  on lake / |
   river wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        836       48.95       48.95
          D |         42        2.46       51.41
          N |        112        6.56       57.96
         SA |        708       41.45       99.41
         SD |         10        0.59      100.00
------------+-----------------------------------
      Total |      1,708      100.00

. /* MOST / LEAST IMPORTANT ATTRIBUTES BROKEN DOWN BY WHETHER ATTRIBUTES WERE PRESENTED IN FORWARD/REVERSE DIRECTION */
> /* MOST / LEAST IMPORTANT ATTRIBUTES BROKEN DOWN BY WHETHER ATTRIBUTES WERE PRESENTED IN FORWARD/REVERSE DIRECTION */
> /* MOST / LEAST IMPORTANT ATTRIBUTES BROKEN DOWN BY WHETHER ATTRIBUTES WERE PRESENTED IN FORWARD/REVERSE DIRECTION */
> 
> d block_f ;

              storage   display    value
variable name   type    format     label      variable label
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
block_f         byte    %9.0g                 Forward / reverse ordering if attributes (=1 if forward, =0 if reverse)

. /* MOST IMPORTANT ATTRIBUTE */
> /* MOST IMPORTANT ATTRIBUTE */
> /* MOST IMPORTANT ATTRIBUTE */
> 
> tab attribute_1 ;

 Q201 - 1st |
       most |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |      1,145       47.61       47.61
         HR |      1,197       49.77       97.38
         MD |         63        2.62      100.00
------------+-----------------------------------
      Total |      2,405      100.00

. tab attribute_1 if block_f == 1 ;

 Q201 - 1st |
       most |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |        564       47.20       47.20
         HR |        601       50.29       97.49
         MD |         30        2.51      100.00
------------+-----------------------------------
      Total |      1,195      100.00

. tab attribute_1 if block_f == 0 ;

 Q201 - 1st |
       most |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |        581       48.02       48.02
         HR |        596       49.26       97.27
         MD |         33        2.73      100.00
------------+-----------------------------------
      Total |      1,210      100.00

. /* LEAST IMPORTANT ATTRIBUTE */
> /* LEAST IMPORTANT ATTRIBUTE */
> /* LEAST IMPORTANT ATTRIBUTE */
> 
> tab attribute_3 ;

     Q201 - |
      Least |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |        156        6.21        6.21
         HR |        216        8.60       14.81
         MD |      2,139       85.19      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. tab attribute_3 if block_f == 1  ;

     Q201 - |
      Least |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |         68        5.43        5.43
         HR |        107        8.55       13.98
         MD |      1,077       86.02      100.00
------------+-----------------------------------
      Total |      1,252      100.00

. tab attribute_3 if block_f == 0  ;

     Q201 - |
      Least |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |         88        6.99        6.99
         HR |        109        8.66       15.65
         MD |      1,062       84.35      100.00
------------+-----------------------------------
      Total |      1,259      100.00

. /* SERIAL NONPARTICIPATION */
> 
> gen serial_nonp_y = ce1*ce2*ce3*ce4 ;

.   label var serial_nonp_y "Serial Nonparticipant - Always Yes" ;

. gen serial_nonp_n = (1-ce1)*(1-ce2)*(1-ce3)*(1-ce4) ;

.   label var serial_nonp_n "Serial Nonparticipant - Always No" ;

. d serial_nonp_y serial_nonp_n ;

              storage   display    value
variable name   type    format     label      variable label
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
serial_nonp_y   float   %9.0g                 Serial Nonparticipant - Always Yes
serial_nonp_n   float   %9.0g                 Serial Nonparticipant - Always No

. tab serial_nonp_y serial_nonp_n ;

    Serial |
Nonpartici |
    pant - |           Serial Nonparticipant - Always No
Always Yes |         0          1          2          4          8 |     Total
-----------+-------------------------------------------------------+----------
        -1 |        30          0          0          0          0 |        30 
         0 |     1,404        426          1          3         37 |     1,871 
         1 |       610          0          0          0          0 |       610 
-----------+-------------------------------------------------------+----------
     Total |     2,044        426          1          3         37 |     2,511 

. sum serial_nonp_y serial_nonp_n ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
serial_non~y |      2,511    .2309837    .4490049         -1          1
serial_non~n |      2,511    .2931103    1.023678          0          8

. gen test = (ce1 == -1) | (ce2 == -1) | (ce3 == -1) | (ce4 == -1) ;

. tab test ;

       test |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      2,437       97.05       97.05
          1 |         74        2.95      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. drop test ;

. di _N ;
2511

. keep resp_id `demos' cost* ce* order* ec_g* ec_m* ec_p* hr_g* hr_m* hr_p* md_g* md_m* md_p* serial* ;

. reshape long cost ce order ec_g ec_m ec_p hr_g hr_m hr_p md_g md_m md_p, i(resp_id) j(seq) ;
(note: j = 1 2 3 4)

Data                               wide   ->   long
-----------------------------------------------------------------------------
Number of obs.                     2511   ->   10044
Number of variables                  87   ->      52
j variable (4 values)                     ->   seq
xij variables:
                  cost1 cost2 ... cost4   ->   cost
                        ce1 ce2 ... ce4   ->   ce
               order1 order2 ... order4   ->   order
                  ec_g1 ec_g2 ... ec_g4   ->   ec_g
                  ec_m1 ec_m2 ... ec_m4   ->   ec_m
                  ec_p1 ec_p2 ... ec_p4   ->   ec_p
                  hr_g1 hr_g2 ... hr_g4   ->   hr_g
                  hr_m1 hr_m2 ... hr_m4   ->   hr_m
                  hr_p1 hr_p2 ... hr_p4   ->   hr_p
                  md_g1 md_g2 ... md_g4   ->   md_g
                  md_m1 md_m2 ... md_m4   ->   md_m
                  md_p1 md_p2 ... md_p4   ->   md_p
-----------------------------------------------------------------------------

. label var seq "CE Sequence ID (not the same as order presented - see ORDER variable)" ;

. di _N ;
10044

. drop if ce == -1 ;
(206 observations deleted)

.  /* CHECK - SENSITIVITY WOULD BE TO DROP ENTIRE OBSERVATION */ 
> di _N ;
9838

. by resp_id : gen test = _N  if _n == _N ;
(7,327 missing values generated)

. tab test ;

       test |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         63        2.51        2.51
          2 |          6        0.24        2.75
          3 |          5        0.20        2.95
          4 |      2,437       97.05      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. drop test ;

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
 paused on:  23 Nov 2021, 16:54:56
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
resumed on:  23 Nov 2021, 16:54:56

. tab ce cost ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       520        703      1,085      2,311 |     4,619 
         1 |     1,688      1,257      1,142      1,132 |     5,219 
-----------+--------------------------------------------+----------
     Total |     2,208      1,960      2,227      3,443 |     9,838 

. tab ce cost if order == 1 ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       147        179        252        493 |     1,071 
         1 |       423        323        308        386 |     1,440 
-----------+--------------------------------------------+----------
     Total |       570        502        560        879 |     2,511 

. tab ce cost if order == 2 ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       109        180        270        569 |     1,128 
         1 |       418        307        307        288 |     1,320 
-----------+--------------------------------------------+----------
     Total |       527        487        577        857 |     2,448 

. tab ce cost if order == 3 ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       135        168        286        598 |     1,187 
         1 |       421        331        274        229 |     1,255 
-----------+--------------------------------------------+----------
     Total |       556        499        560        827 |     2,442 

. tab ce cost if order == 4 ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       129        176        277        651 |     1,233 
         1 |       426        296        253        229 |     1,204 
-----------+--------------------------------------------+----------
     Total |       555        472        530        880 |     2,437 

. /* PERCENT OF PEOPLE WHO SAY YES */
> /* PERCENT OF PEOPLE WHO SAY YES */
> /* PERCENT OF PEOPLE WHO SAY YES */
> 
> by cost: sum ce ;

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |      2,208    .7644928    .4244115          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |      1,960    .6413265    .4797335          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |      2,227    .5127975    .4999485          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |      3,443     .328783    .4698392          0          1


. /* QUESTION #1 */
> /* QUESTION #1 */
> /* QUESTION #1 */
> by cost: sum ce if order == 1 ;

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        570    .7421053      .43786          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        502    .6434263    .4794652          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        560         .55    .4979385          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        879    .4391354    .4965642          0          1


. /* QUESTION #2 */
> /* QUESTION #2 */
> /* QUESTION #2 */
> by cost: sum ce if order == 2 ;

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        527    .7931689    .4054182          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        487    .6303901    .4831954          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        577    .5320624    .4994039          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        857     .336056    .4726341          0          1


. /* QUESTION #3 */
> /* QUESTION #3 */
> /* QUESTION #3 */
> by cost: sum ce if order == 3 ;

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        556    .7571942    .4291648          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        499    .6633267    .4730463          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        560    .4892857    .5003321          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        827    .2769045    .4477396          0          1


. /* QUESTION #4 */
> /* QUESTION #4 */
> /* QUESTION #4 */
> by cost: sum ce if order == 4 ;

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        555    .7675676    .4227643          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        472    .6271186     .484084          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        530    .4773585     .499959          0          1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        880    .2602273     .439008          0          1


. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
 paused on:  23 Nov 2021, 16:54:56
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
resumed on:  23 Nov 2021, 16:54:56

. sum survey_duration, detail ;

                  Survey duration (minutes)
-------------------------------------------------------------
      Percentiles      Smallest
 1%     6.183333       3.566667
 5%     9.066667       3.566667
10%     10.66667       3.566667       Obs               9,838
25%     14.13333       3.566667       Sum of Wgt.       9,838

50%       20.075                      Mean           120.1987
                        Largest       Std. Dev.      886.5874
75%     30.16667          19989
90%     49.86666          19989       Variance       786037.2
95%         81.1          19989       Skewness       13.33985
99%     2965.467          19989       Kurtosis       214.6129

. tab debrief_3 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     choose |
 disagree - |
       trap |
   question |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        296        3.08        3.08
          D |      8,736       90.77       93.85
          N |        348        3.62       97.46
         SA |        128        1.33       98.79
         SD |        116        1.21      100.00
------------+-----------------------------------
      Total |      9,624      100.00

. tab debrief_1 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 my answers |
      might |
  influence |
  design of |
     future |
   policies |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      4,724       49.09       49.09
          D |        576        5.99       55.07
          N |      2,996       31.13       86.20
         SA |      1,132       11.76       97.96
         SD |        196        2.04      100.00
------------+-----------------------------------
      Total |      9,624      100.00

. tab debrief_2 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 believable |
    that my |
  household |
 would have |
     to pay |
    higher  |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      5,068       52.66       52.66
          D |        272        2.83       55.49
          N |        776        8.06       63.55
         SA |      3,404       35.37       98.92
         SD |        104        1.08      100.00
------------+-----------------------------------
      Total |      9,624      100.00

. /* DROPPING:                                                                            */
> /*    1) SPEEDING PEOPLE (<=8 MINUTES TO COMPLETE SURVEY)                               */
> /*    2) PEOPLE WHO TAKE MORE THAN A WEEK TO COMPLETE THE SURVEY                        */
> /*    3) PEOPLE WHO FAIL THE TRAP QUESTION                                              */
> /*    4) PEOPLE WHO DISAGREE OR STRONGLY DISAGREE WITH THE CONSEQUENTIALITY STATEMENTS  */
> 
> keep if survey_duration >= 8 & survey_duration <= (7*24*60) & inlist(debrief_3,"D") & !inlist(debrief_1,"D","SD") & !inlist(debrief_2,"D","SD") ;
(2,254 observations deleted)

. sort resp_id seq ;

. by resp_id : assert wgt_final[1] == wgt_final ;

. gen double inv_dist = (1/near_dist) ;

. gen cost_dis = cost/(1+near_dist) ;

. logit ce cost          ec_g ec_p hr_g hr_p md_g md_p age gender white college [pw=wgt_final], cluster(resp_id) ;

Iteration 0:   log pseudolikelihood = -4191743.7  
Iteration 1:   log pseudolikelihood = -3687122.1  
Iteration 2:   log pseudolikelihood = -3686029.4  
Iteration 3:   log pseudolikelihood = -3686029.3  

Logistic regression                             Number of obs     =      7,584
                                                Wald chi2(11)     =     512.68
                                                Prob > chi2       =     0.0000
Log pseudolikelihood = -3686029.3               Pseudo R2         =     0.1206

                            (Std. Err. adjusted for 1,896 clusters in resp_id)
------------------------------------------------------------------------------
             |               Robust
          ce |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
        cost |  -.0561872   .0034198   -16.43   0.000    -.0628898   -.0494846
        ec_g |   .0162029    .003597     4.50   0.000      .009153    .0232528
        ec_p |  -.0152104   .0038619    -3.94   0.000    -.0227796   -.0076411
        hr_g |   .0113868   .0029719     3.83   0.000      .005562    .0172116
        hr_p |  -.0248146   .0087398    -2.84   0.005    -.0419444   -.0076848
        md_g |   .0078538   .0022209     3.54   0.000      .003501    .0122066
        md_p |  -.0021807   .0047154    -0.46   0.644    -.0114227    .0070614
         age |  -.0162309    .002857    -5.68   0.000    -.0218305   -.0106312
      gender |  -.1008659   .1026613    -0.98   0.326    -.3020784    .1003466
       white |  -.2496793   .1215481    -2.05   0.040    -.4879092   -.0114494
     college |   .2653966   .1025011     2.59   0.010     .0644982     .466295
       _cons |   1.288001   .2250702     5.72   0.000     .8468716    1.729131
------------------------------------------------------------------------------

. nlcom wtp : -12*(_b[ec_g]-_b[ec_p]+_b[hr_g]-_b[hr_p]+_b[md_g]-_b[md_p])/_b[cost] ;

         wtp:  -12*(_b[ec_g]-_b[ec_p]+_b[hr_g]-_b[hr_p]+_b[md_g]-_b[md_p])/_b[cost]

------------------------------------------------------------------------------
          ce |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
         wtp |   16.58366   2.791154     5.94   0.000      11.1131    22.05422
------------------------------------------------------------------------------

.                                /* WTP TO CLEAN UP ONE MILE OF STREAM FROM WORST TO BEST CATEGORIES */
> 
> logit ce cost cost_dis ec_g ec_p hr_g hr_p md_g md_p age gender white college [pw=wgt_final], cluster(resp_id) ;

Iteration 0:   log pseudolikelihood = -4191743.7  
Iteration 1:   log pseudolikelihood = -3684516.7  
Iteration 2:   log pseudolikelihood =   -3683448  
Iteration 3:   log pseudolikelihood = -3683447.9  

Logistic regression                             Number of obs     =      7,584
                                                Wald chi2(12)     =     514.22
                                                Prob > chi2       =     0.0000
Log pseudolikelihood = -3683447.9               Pseudo R2         =     0.1213

                            (Std. Err. adjusted for 1,896 clusters in resp_id)
------------------------------------------------------------------------------
             |               Robust
          ce |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
        cost |  -.0610311   .0046437   -13.14   0.000    -.0701326   -.0519295
    cost_dis |   .0401019   .0250425     1.60   0.109    -.0089804    .0891843
        ec_g |   .0162943   .0035968     4.53   0.000     .0092448    .0233438
        ec_p |  -.0151874   .0038603    -3.93   0.000    -.0227535   -.0076213
        hr_g |   .0114533   .0029718     3.85   0.000     .0056287    .0172779
        hr_p |  -.0247109   .0087397    -2.83   0.005    -.0418405   -.0075814
        md_g |   .0079231   .0022232     3.56   0.000     .0035657    .0122805
        md_p |  -.0021735   .0047079    -0.46   0.644    -.0114009    .0070539
         age |  -.0162039   .0028559    -5.67   0.000    -.0218013   -.0106064
      gender |  -.0959678   .1028224    -0.93   0.351     -.297496    .1055604
       white |   -.257121   .1215866    -2.11   0.034    -.4954263   -.0188157
     college |   .2558948   .1027845     2.49   0.013     .0544409    .4573488
       _cons |   1.293062   .2249336     5.75   0.000     .8522005    1.733924
------------------------------------------------------------------------------

. nlcom wtp : -12*(_b[ec_g]-_b[ec_p]+_b[hr_g]-_b[hr_p]+_b[md_g]-_b[md_p])/(_b[cost]+_b[cost_dis]/(1+ 9.584872)) ;

         wtp:  -12*(_b[ec_g]-_b[ec_p]+_b[hr_g]-_b[hr_p]+_b[md_g]-_b[md_p])/(_b[cost]+_b[cost_dis]/(1+ 9.584872))

------------------------------------------------------------------------------
          ce |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
         wtp |   16.29752   2.734841     5.96   0.000     10.93733    21.65771
------------------------------------------------------------------------------

.   /* WTP FOR PERSON LIVING AVERAGE DISTANCE FROM CENTROID CLEANED-UP STREAMS */
> nlcom wtp : -12*(_b[ec_g]-_b[ec_p]+_b[hr_g]-_b[hr_p]+_b[md_g]-_b[md_p])/(_b[cost]+_b[cost_dis]/(1+ 1)) ;

         wtp:  -12*(_b[ec_g]-_b[ec_p]+_b[hr_g]-_b[hr_p]+_b[md_g]-_b[md_p])/(_b[cost]+_b[cost_dis]/(1+ 1))

------------------------------------------------------------------------------
          ce |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
         wtp |   22.76496   6.681436     3.41   0.001     9.669586    35.86034
------------------------------------------------------------------------------

.          /* WTP FOR PERSON LIVING ONE MILE         FROM CENTROID CLEANED-UP STREAMS */
> 
> log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
 paused on:  23 Nov 2021, 16:54:58
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
resumed on:  23 Nov 2021, 16:54:58

. d ;

Contains data from data\estimation_data.dta
  obs:         7,584                          
 vars:            37                          23 Nov 2021 16:54
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
resp_id         int     %9.0g                 Respondent ID
seq             byte    %10.0g                CE Sequence ID (not the same as order presented - see ORDER variable)
ce_cnt          float   %9.0g                 # of choice occasions
nonpart         float   %9.0g                 = 1 if serial nonparticipant
block_f         byte    %9.0g                 Forward / reverse ordering if attributes (=1 if forward, =0 if reverse)
gender          float   %9.0g                 Q55 - Gender (= 1 if Male)
age             float   %9.0g                 Q56 - Age
income          float   %9.0g                 Q59 - Household Income
employ_status   byte    %9.0g                 Q710 - Employment status (1=ft,2=pt,3=un,4=ret,5=home,6=stu,7=disable,8=other)
own_rent        byte    %9.0g                 Q61 - 1 if own main residence, 2 if rent, 3 if other
water_bill      float   %9.0g                 = 1 if respondent directly pays water bill
educ            byte    %10.0g                Q60 - Education (0=none,1=some<12,2=hs dipl,3=some coll,4=AB,5=BA/BS,6=grad/prof
college         float   %9.0g                 = 1 if respondent has a 4-year college degree
adults          float   %9.0g                 Q69 - Adults >= 18
kids            float   %9.0g                 Q70 - Kids < 18
resident        byte    %9.0g                 Q48 - Years as county resident (1 = < 1 yr, 2 = 1/2, 3 = 3/5, 4 = 6/10, 5 = 10+)
native          float   %9.0g                 Q64 - 1 if American Indian or Alaska Native
asian           float   %9.0g                 Q64 - 1 if Asian
black           float   %9.0g                 Q64 - 1 if Black or African American
white           float   %9.0g                 Q64 - 1 if White
other           float   %9.0g                 Q64 - 1 if Other
hisp_latino     float   %9.0g                 Q63 - 1 if Hispanic, Latino or Spanish origin
phone           byte    %9.0g                 Q84 = 1 if survey accessed thru phone
cost            byte    %8.0g                 Action Plan Cost
ce              byte    %9.0g                 Action Plan Vote (1 = Yes, 0 = No)
order           byte    %9.0g                 Ordering of CEs (1 = First, 4 = Last)
ec_g            byte    %8.0g                 Ecosystem Conditions = % Good w/ Action Plan
ec_m            byte    %9.0g                 Ecosystem Conditions = % Fair w/ Action Plan
ec_p            byte    %8.0g                 Ecosystem Conditions = % Poor w/ Action Plan
hr_g            byte    %8.0g                 Health Risk = % Good w/ Action Plan
hr_m            byte    %9.0g                 Health Risk = % Fair w/ Action Plan
hr_p            byte    %8.0g                 Health Risk = % Poor w/ Action Plan
md_g            byte    %8.0g                 Murky Water Days = % Good w/ Action Plan
md_m            byte    %9.0g                 Murky Water Days = % Fair w/ Action Plan
md_p            byte    %8.0g                 Murky Water Days = % Poor w/ Action Plan
near_dist       double  %10.0g                Distance to Impacted Creeks
wgt_final       double  %10.0g                Final sampling weights
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sorted by: resp_id  seq
     Note: Dataset has changed since last saved.

. sum ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     resp_id |      7,584    1266.371    719.7683          2       2511
         seq |      7,584         2.5    1.118108          1          4
      ce_cnt |      7,584           4           0          4          4
     nonpart |      7,584    .1360759    .3428918          0          1
     block_f |      7,584    .5058017    .4999993          0          1
-------------+---------------------------------------------------------
      gender |      7,584    .4641303    .4951871          0          1
         age |      7,584    51.10127    16.32762         18         90
      income |      7,584    102132.7    62456.07      10000     225000
employ_sta~s |      7,584    2.263186    1.820317         -1          8
    own_rent |      7,584    1.220992    .5358834         -1          3
-------------+---------------------------------------------------------
  water_bill |      7,584    .8605204      .34423          0          1
        educ |      7,584    4.779536    1.374941         -1          6
     college |      7,584    .7480163    .4312251          0          1
      adults |      7,584    1.978374    .8746019          1          7
        kids |      7,584    .5773636    1.011149          0         10
-------------+---------------------------------------------------------
    resident |      7,584    4.310127    1.220002         -1          5
      native |      7,584    .0129897    .1117882          0          1
       asian |      7,584    .0490134    .2136693          0          1
       black |      7,584    .1471965    .3505078          0          1
       white |      7,584    .7675108    .4179231          0          1
-------------+---------------------------------------------------------
       other |      7,584     .056775    .2286025          0          1
 hisp_latino |      7,584    .0464167    .2079986          0          1
       phone |      7,584    .2136076    .4098799          0          1
        cost |      7,584     17.9822    11.35942          4         32
          ce |      7,584     .556039    .4968825          0          1
-------------+---------------------------------------------------------
       order |      7,584         2.5    1.118108          1          4
        ec_g |      7,584    12.17181    9.325471          2         24
        ec_m |      7,584   -.5700158    12.30478        -22         22
        ec_p |      7,584   -11.60179    9.263199        -24         -2
        hr_g |      7,584    13.68091    10.62504          2         27
-------------+---------------------------------------------------------
        hr_m |      7,584   -7.554061    11.04007        -25          9
        hr_p |      7,584   -6.126846    3.759554        -11         -2
        md_g |      7,584    16.16851    13.12621          2         33
        md_m |      7,584   -4.694093    14.76512        -30         19
        md_p |      7,584   -11.47442    7.662685        -21         -3
-------------+---------------------------------------------------------
   near_dist |      7,584    9.535896    4.666071   .2335068   22.94525
   wgt_final |      7,584    804.9147    735.9781   79.42957   4538.985

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
 paused on:  23 Nov 2021, 16:54:58
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
resumed on:  23 Nov 2021, 16:54:58

. d ;

Contains data from data\estimation_data.dta
  obs:         1,896                          
 vars:             4                          23 Nov 2021 16:54
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
resp_id         int     %9.0g                 Respondent ID
ce_cnt          float   %9.0g                 # of choice occasions
nonpart         float   %9.0g                 = 1 if serial nonparticipant
wgt_final       double  %10.0g                Final sampling weights
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sorted by: resp_id
     Note: Dataset has changed since last saved.

. sum ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     resp_id |      1,896    1266.371    719.9107          2       2511
      ce_cnt |      1,896           4           0          4          4
     nonpart |      1,896    .1360759    .3429597          0          1
   wgt_final |      1,896    804.9147    736.1237   79.42957   4538.985

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\3-analysis.log
  log type:  text
 paused on:  23 Nov 2021, 16:54:58
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
